﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.Sql;

/// <summary>
///UserType 的摘要说明
/// </summary>
public class UserType
{
	public UserType()
	{
		//
		//TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 获取指挥中心表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetCenterTableType()
    {
        DataTable Center = new DataTable();
        Center.Columns.Add("CenterId", typeof(int));
        Center.Columns.Add("NAME", typeof(string));

        return Center;
 
    }
    /// <summary>
    /// 获取大区表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetRegionTableType()
    {
        DataTable Region = new DataTable();
        Region.Columns.Add("RegionId", typeof(int));
        Region.Columns.Add("NAME", typeof(string));

        return Region;

    }
    /// <summary>
    /// 获取城市表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetCityTableType()
    {
        DataTable City = new DataTable();
        City.Columns.Add("CityId", typeof(int));
        City.Columns.Add("CenterId", typeof(int));
        City.Columns.Add("CenterName", typeof(string));
        City.Columns.Add("NAME", typeof(string));
        City.Columns.Add("ParentId", typeof(int));
        return City;

    }
    /// <summary>
    /// 获取用户权限表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetUserPermisionTableType()
    {
        DataTable UserPermision = new DataTable();
        UserPermision.Columns.Add("UserId", typeof(int));
        UserPermision.Columns.Add("MenuId", typeof(int));
        UserPermision.Columns.Add("PermisionId", typeof(int));

        return UserPermision;

    }
    /// <summary>
    /// 获取用户组权限表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetGroupPermisionTableType()
    {
        DataTable GroupPermision = new DataTable();
        GroupPermision.Columns.Add("GroupId", typeof(int));
        GroupPermision.Columns.Add("MenuId", typeof(int));
        GroupPermision.Columns.Add("PermisionId", typeof(int));

        return GroupPermision;

    }
    /// <summary>
    /// 获取用户组计划课程表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetGroupClassTableType()
    {
        DataTable GroupClass = new DataTable();
        GroupClass.Columns.Add("GroupClassId", typeof(int));
        GroupClass.Columns.Add("GroupId", typeof(int));
        GroupClass.Columns.Add("ClassId", typeof(int));
        GroupClass.Columns.Add("StartDate", typeof(DateTime));
        GroupClass.Columns.Add("EndDate", typeof(DateTime));
        return GroupClass;

    }
    /// <summary>
    /// 获取部门类型表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetDeptTypeTableType()
    {
        DataTable DeptType = new DataTable();
        DeptType.Columns.Add("DeptTypeId", typeof(int));
        DeptType.Columns.Add("NAME", typeof(string));
     

        return DeptType;

    }
    /// <summary>
    /// 获取部门表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetDeptTableType()
    {
        DataTable Dept = new DataTable();
        Dept.Columns.Add("DeptId", typeof(int));
        Dept.Columns.Add("DeptTypeId", typeof(int));
        Dept.Columns.Add("DeptTypeName", typeof(string));
        Dept.Columns.Add("NAME", typeof(string));

        return Dept;

    }
    /// <summary>
    /// 获取员工级别表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetEmpLevelTableType()
    {
        DataTable EmpLevel = new DataTable();
        EmpLevel.Columns.Add("EmpLevelId", typeof(int));
        EmpLevel.Columns.Add("NAME", typeof(string));
        return EmpLevel;

    }
    /// <summary>
    /// 获取职务级别表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetGradeTableType()
    {
        DataTable Grade = new DataTable();
        Grade.Columns.Add("GradeId", typeof(int));
        Grade.Columns.Add("NAME", typeof(string));
        return Grade;

    }
    /// <summary>
    /// 获取职位表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetJobTableType()
    {
        DataTable Job = new DataTable();
        Job.Columns.Add("JobId", typeof(int));
        Job.Columns.Add("NAME", typeof(string));
        return Job;

    }
    /// <summary>
    /// 获取课程类型表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetClassTypeTableType()
    {
        DataTable ClassType = new DataTable();
        ClassType.Columns.Add("ClassTypeId", typeof(int));
        ClassType.Columns.Add("NAME", typeof(string));
        return ClassType;

    }
    /// <summary>
    /// 获取课程表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetClassTableType()
    {
        DataTable ClassTable = new DataTable();
        ClassTable.Columns.Add("ClassId", typeof(int));
        ClassTable.Columns.Add("ClassTypeId", typeof(int));
        ClassTable.Columns.Add("ClassTypeName", typeof(string));
        ClassTable.Columns.Add("Code", typeof(string));
        ClassTable.Columns.Add("Name", typeof(string));
        ClassTable.Columns.Add("Time", typeof(decimal));
        ClassTable.Columns.Add("UserId", typeof(int));
        ClassTable.Columns.Add("IsValid", typeof(int));
        ClassTable.Columns.Add("ModifyDate", typeof(DateTime));
        ClassTable.Columns.Add("PassScore", typeof(decimal));
        ClassTable.Columns.Add("BackgroundMusic", typeof(string));
        return ClassTable;

    }
    /// <summary>
    /// 获取品牌表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetBrandTableType()
    {
        DataTable Brand = new DataTable();
        Brand.Columns.Add("BrandId", typeof(int));
        Brand.Columns.Add("NAME", typeof(string));
        return Brand;

    }
    /// <summary>
    /// 获取导师类型表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetTeacherTypeTableType()
    {
        DataTable TeacherType = new DataTable();
        TeacherType.Columns.Add("TeacherTypeId", typeof(int));
        TeacherType.Columns.Add("NAME", typeof(string));
        return TeacherType;

    }
    /// <summary>
    /// 获取店铺表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetStoreTableType()
    {
        DataTable Store = new DataTable();
        Store.Columns.Add("StoreId", typeof(int));
        Store.Columns.Add("Code", typeof(string));
        Store.Columns.Add("NAME", typeof(string));
        return Store;

    }
    /// <summary>
    /// 获取客户表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetCustomerTableType()
    {
        DataTable Customer = new DataTable();
        Customer.Columns.Add("CustomerId", typeof(int));
        Customer.Columns.Add("CenterId", typeof(int));
        Customer.Columns.Add("CenterName", typeof(string));
        Customer.Columns.Add("Code", typeof(string));
        Customer.Columns.Add("Name", typeof(string));
    
        return Customer;

    }

    /// <summary>
    /// 获取员工表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetEmpTableType()
    {
        DataTable Emp = new DataTable();
        Emp.Columns.Add("EmpId", typeof(int));
        Emp.Columns.Add("EmpTypeId", typeof(int));
        Emp.Columns.Add("EmpTypeName", typeof(string));
        Emp.Columns.Add("CustomerId", typeof(int));
        Emp.Columns.Add("CustomerCode", typeof(string));
        Emp.Columns.Add("CustomerName", typeof(string));
        Emp.Columns.Add("GradeId", typeof(int));
        Emp.Columns.Add("GradeName", typeof(string));
        Emp.Columns.Add("EntryDate", typeof(DateTime));
        Emp.Columns.Add("LeaveDate", typeof(DateTime));
        Emp.Columns.Add("IsTeacher", typeof(int));
        Emp.Columns.Add("FinishClass", typeof(int));
        Emp.Columns.Add("CenterId", typeof(int));
        Emp.Columns.Add("CenterName", typeof(string));
        Emp.Columns.Add("CityId", typeof(int));
        Emp.Columns.Add("CityName", typeof(string));
        Emp.Columns.Add("DeptTypeId", typeof(int));
        Emp.Columns.Add("DeptTypeName", typeof(string));
        Emp.Columns.Add("DeptId", typeof(int));
        Emp.Columns.Add("DeptName", typeof(string));
        Emp.Columns.Add("BrandId", typeof(int));
        Emp.Columns.Add("BrandName", typeof(string));
        Emp.Columns.Add("StoreId", typeof(int));
        Emp.Columns.Add("StoreCode", typeof(string));
        Emp.Columns.Add("StoreName", typeof(string));
        Emp.Columns.Add("Code", typeof(string));
        Emp.Columns.Add("Name", typeof(string));
        Emp.Columns.Add("JobId", typeof(int));
        Emp.Columns.Add("JobName", typeof(string));
        return Emp;

    }
    /// <summary>
    /// 获取员工类型表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetEmpTypeTableType()
    {
        DataTable EmpType = new DataTable();
        EmpType.Columns.Add("EmpTypeId", typeof(int));
        EmpType.Columns.Add("NAME", typeof(string));
        return EmpType;

    }
    /// <summary>
    /// 获取可以独立授课的课程表
    /// </summary>
    /// <returns></returns>
    public DataTable GetTeacherTableType()
    {
        DataTable TeacherTableType = new DataTable();
        TeacherTableType.Columns.Add("TeacherId", typeof(int));
        TeacherTableType.Columns.Add("EmpId", typeof(int));
        TeacherTableType.Columns.Add("ClassId", typeof(int));
        return TeacherTableType;
    }
    /// <summary>
    /// 获取正在学习讲授的课程表
    /// </summary>
    /// <returns></returns>
    public DataTable GetStudyTableType()
    {
        DataTable StudyTableType = new DataTable();
        StudyTableType.Columns.Add("StudyId", typeof(int));
        StudyTableType.Columns.Add("EmpId", typeof(int));
        StudyTableType.Columns.Add("ClassId", typeof(int));
        StudyTableType.Columns.Add("StartDate", typeof(DateTime));
        StudyTableType.Columns.Add("EndDate", typeof(DateTime));
        return StudyTableType;
    }
    /// <summary>
    /// 获取输入记录前已完成的课程表
    /// </summary>
    /// <returns></returns>
    public DataTable GetInitialTableType()
    {
        DataTable InitialTableType = new DataTable();
        InitialTableType.Columns.Add("InitialId", typeof(int));
        InitialTableType.Columns.Add("EmpId", typeof(int));
        InitialTableType.Columns.Add("ClassId", typeof(int));

        return InitialTableType;
    }

    /// <summary>
    /// 获取计划和实际完成课程表
    /// </summary>
    /// <returns></returns>
    public DataTable GetPlanFinishTableType()
    {
        DataTable PlanFinishTableType = new DataTable();
        PlanFinishTableType.Columns.Add("PlanFinishId", typeof(int));
        PlanFinishTableType.Columns.Add("ClassEmpId", typeof(int));
        PlanFinishTableType.Columns.Add("Period", typeof(string));
        PlanFinishTableType.Columns.Add("ClassId", typeof(int));
        PlanFinishTableType.Columns.Add("EmpId", typeof(int));
        PlanFinishTableType.Columns.Add("StudyDate", typeof(DateTime));
        PlanFinishTableType.Columns.Add("FinishDate", typeof(DateTime));
        PlanFinishTableType.Columns.Add("Score", typeof(decimal));
        return PlanFinishTableType;
    }

    /// <summary>
    /// 获取课程记录表
    /// </summary>
    /// <returns></returns>
    public DataTable GetRecordTableType()
    {
        DataTable RecordTableType = new DataTable();
        RecordTableType.Columns.Add("RecordId", typeof(int));
        RecordTableType.Columns.Add("ClassRecordId", typeof(int));
        RecordTableType.Columns.Add("EmpTypeId", typeof(int));
        RecordTableType.Columns.Add("ClassId", typeof(int));
        RecordTableType.Columns.Add("Time", typeof(decimal));
        RecordTableType.Columns.Add("RegionId", typeof(int));
        RecordTableType.Columns.Add("Satisficing", typeof(int));
        RecordTableType.Columns.Add("TeacherCode", typeof(string));
        RecordTableType.Columns.Add("TeacherName", typeof(string));
        RecordTableType.Columns.Add("PlanTimes", typeof(int));
        RecordTableType.Columns.Add("OpenTime", typeof(string));
        RecordTableType.Columns.Add("CustomerId", typeof(int));
        RecordTableType.Columns.Add("GradeId", typeof(int));
        RecordTableType.Columns.Add("EmpLevelId", typeof(int));
        RecordTableType.Columns.Add("TeacherTypeId", typeof(int));
        RecordTableType.Columns.Add("CenterId", typeof(int));
        RecordTableType.Columns.Add("CityId", typeof(int));
        RecordTableType.Columns.Add("FactTimes", typeof(int));
        return RecordTableType;
    }

    /// <summary>
    /// 获取用户表
    /// </summary>
    /// <returns></returns>
    public DataTable GetUserTableType()
    {
        DataTable UserTableType = new DataTable();
        UserTableType.Columns.Add("UserId", typeof(int));
        UserTableType.Columns.Add("Code", typeof(string));
        UserTableType.Columns.Add("Name", typeof(string));
        UserTableType.Columns.Add("PWD", typeof(string));
        UserTableType.Columns.Add("IsValid", typeof(int));
        return UserTableType;
    }
    /// <summary>
    /// 获取课程练习题的回答表类型
    /// </summary>
    /// <returns></returns>
    public DataTable GetAnswerTableType()
    {
        DataTable AnswerTableType = new DataTable();
        AnswerTableType.Columns.Add("AnswerId", typeof(int));
        AnswerTableType.Columns.Add("StudyAnswerId", typeof(int));
        AnswerTableType.Columns.Add("EmpId", typeof(int));
        AnswerTableType.Columns.Add("ExercisesId", typeof(int));
        AnswerTableType.Columns.Add("Answer", typeof(string));
        AnswerTableType.Columns.Add("AnswerDate", typeof(DateTime));
        AnswerTableType.Columns.Add("Score", typeof(decimal));
        return AnswerTableType;
    }
}